package src.lab03.Test14;

import java.sql.*;

/**
 * Created by 卡01 on 2017/12/7.
 */
public class Test { public static void main(String[] args) throws ClassNotFoundException, SQLException {
    //3+1
    Connection connection=null;
    Statement statement=null;
    ResultSet resultSet=null;
    String sql="select * from t_userinfo";
    try {
        Class.forName("com.mysql.jdbc.Driver");
        connection= DriverManager.getConnection(
                "jdbc:mysql://localhost:3306/java_2017?serverTimezone=UTC",
                "root",
                "123456"
        );
        statement =connection.createStatement();
        resultSet=statement.executeQuery(sql);
        while (resultSet.next()){
            System.out.println(resultSet.getString(1));
            System.out.println(resultSet.getString(2));
            System.out.println(resultSet.getString(3));
            System.out.println(resultSet.getString(4));
        }
    }catch (ClassNotFoundException e){
        e.printStackTrace();
    }catch (SQLException e){
        e.printStackTrace();
    }finally {
        try{
            statement.close();
            connection.close();
        }catch (SQLException e){
            e.printStackTrace();}
    }



}
}
